<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateTryMessageTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('try_message', function (Blueprint $table) {
            $table->increments('id');
            $table->string('sex')->nullable()->comment('性别');
            $table->string('open_id')->default('')->comment('openid');
            $table->string('age')->nullable()->comment('年龄');
            $table->string('city')->nullable()->comment('城市');
            $table->string('occ')->nullable()->comment('职业');
            $table->string('money')->nullable()->comment('私房钱');
            $table->string('live')->nullable()->comment('居住');
            $table->string('label')->nullable()->comment('标签');
            $table->string('recommend')->nullable()->comment('推荐自己');
            $table->integer('status')->nullable()->default('0')->comment('是否选中');
            $table->string('uuid')->nullable()->default('')->comment('唯一标识码');
            $table->text('img')->nullable()->comment('产品图片');
            $table->string('evaluate')->nullable()->comment('评价');
            $table->string('name')->nullable()->comment('姓名');
            $table->string('address')->nullable()->comment('地址');
            $table->string('phone')->nullable()->comment('电话');
            $table->text('remarks')->nullable()->comment('备注');
            $table->integer('examine')->nullable()->default('0')->comment('审核');
            $table->integer('deliver')->nullable()->default('0')->comment('是否发货');
            $table->integer('examine_te')->nullable()->default('0')->comment('审核');
            $table->integer('deliver_te')->nullable()->default('0')->comment('是否发货');
            $table->integer('status_te')->nullable()->default('0')->comment('是否选中');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('try_message');
    }
}
